1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
|
// app/api/stage-submissions/[id]/route.ts
import { NextRequest, NextResponse } from "next/server"
import { getServerSession } from "next-auth/next"
import { authOptions } from "@/app/api/auth/[...nextauth]/route"
import db from "@/db/db"
import { stageSubmissions, stageSubmissionAttachments } from "@/db/schema"
import { eq, and } from "drizzle-orm"
export async function GET(
request: NextRequest,
{ params }: { params: { id: string } }
) {
try {
const session = await getServerSession(authOptions)
if (!session?.user?.companyId) {
return NextResponse.json({ error: "Unauthorized" }, { status: 401 })
}
const vendorId = session.user.companyId
const submissionId = parseInt(params.id)
if (isNaN(submissionId)) {
return NextResponse.json({ error: "Invalid submission ID" }, { status: 400 })
}
// submission 정보 조회 (벤더 검증 포함)
const submission = await db
.select()
.from(stageSubmissions)
.where(
and(
eq(stageSubmissions.id, submissionId),
eq(stageSubmissions.vendorId, vendorId)
)
)
.limit(1)
if (submission.length === 0) {
return NextResponse.json(
{ error: "Submission not found" },
{ status: 404 }
)
}
// 첨부 파일 조회
const files = await db
.select({
id: stageSubmissionAttachments.id,
originalFileName: stageSubmissionAttachments.originalFileName,
fileSize: stageSubmissionAttachments.fileSize,
uploadedAt: stageSubmissionAttachments.uploadedAt,
syncStatus: stageSubmissionAttachments.syncStatus,
storageUrl: stageSubmissionAttachments.storageUrl,
fileType: stageSubmissionAttachments.fileType,
status: stageSubmissionAttachments.status,
})
.from(stageSubmissionAttachments)
.where(eq(stageSubmissionAttachments.submissionId, submissionId))
.orderBy(stageSubmissionAttachments.uploadedAt)
// 응답 데이터 구성
const result = {
id: submission[0].id,
revisionNumber: submission[0].revisionNumber,
submissionStatus: submission[0].submissionStatus,
reviewStatus: submission[0].reviewStatus,
reviewComments: submission[0].reviewComments,
submittedBy: submission[0].submittedBy,
submittedAt: submission[0].submittedAt,
submissionTitle: submission[0].submissionTitle,
submissionDescription: submission[0].submissionDescription,
files: files.filter(f => f.status === "ACTIVE"), // 활성 파일만
}
return NextResponse.json(result)
} catch (error) {
console.error("Error fetching submission detail:", error)
return NextResponse.json(
{ error: "Internal server error" },
{ status: 500 }
)
}
}
|
